<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file="../common/commonPrint.jsp" %>
<%@page import="com.hz.framework.dao.CommonDBDao,java.net.URLEncoder"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
	String sql = (String)request.getParameter("sqlprint");
	request.setAttribute("listinfo",CommonDBDao.staticList(sql,true));
	response.setHeader("Content-Disposition","attachment; filename="+URLEncoder.encode("供应商信息列表", "UTF-8") + ".xls");
	
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="供应商信息列表.files/filelist.xml">
<link rel=Edit-Time-Data href="供应商信息列表.files/editdata.mso">
<link rel=OLE-Object-Data href="供应商信息列表.files/oledata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
x\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>供应商信息列表</title>
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:LastAuthor>QQ</o:LastAuthor>
  <o:LastPrinted>2012-01-13T07:03:12Z</o:LastPrinted>
  <o:Created>2011-12-16T01:49:50Z</o:Created>
  <o:LastSaved>2012-01-13T07:04:43Z</o:LastSaved>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:.39in .39in .39in .39in;
	mso-header-margin:.51in;
	mso-footer-margin:.51in;
	mso-page-orientation:landscape;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding:0px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	mso-number-format:000000;}
.xl25
	{mso-style-parent:style0;
	font-weight:700;}
.xl26
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;
	background:silver;
	mso-pattern:auto none;}
.xl27
	{mso-style-parent:style0;
	font-weight:700;
	mso-number-format:000000;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:silver;
	mso-pattern:auto none;}
.xl28
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:silver;
	mso-pattern:auto none;}
.xl29
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;
	border-top:.5pt solid windowtext;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;
	background:silver;
	mso-pattern:auto none;}
.xl30
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:.5pt solid windowtext;}
.xl31
	{mso-style-parent:style0;
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl32
	{mso-style-parent:style0;
	mso-number-format:"Short Date";
	text-align:center;
	border-top:none;
	border-right:.5pt solid windowtext;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
.xl33
	{mso-style-parent:style0;
	font-size:26.0pt;
	font-weight:700;
	font-family:华文行楷;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	text-align:center;
	vertical-align:middle;
	border-top:none;
	border-right:none;
	border-bottom:.5pt solid windowtext;
	border-left:none;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>print 1 </x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:PaperSizeIndex>9</x:PaperSizeIndex>
      <x:Scale>70</x:Scale>
      <x:HorizontalResolution>600</x:HorizontalResolution>
      <x:VerticalResolution>600</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:DoNotDisplayGridlines/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:RangeSelection>$A$1:$P$1</x:RangeSelection>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>11820</x:WindowHeight>
  <x:WindowWidth>18195</x:WindowWidth>
  <x:WindowTopX>480</x:WindowTopX>
  <x:WindowTopY>90</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
</head>
<body link=blue vlink=purple>

<table x:str border=0 cellpadding=0 cellspacing=0 width=1444 style='border-collapse:
 collapse;table-layout:fixed;width:1084pt'>
 <col class=xl24 width=31 style='mso-width-source:userset;mso-width-alt:992;width:23pt'>
 <col width=116 style='mso-width-source:userset;mso-width-alt:3712;width:87pt'>
 <col width=114 style='mso-width-source:userset;mso-width-alt:3648;width:86pt'>
 <col width=68 style='mso-width-source:userset;mso-width-alt:2176;width:51pt'>
 <col width=45 style='mso-width-source:userset;mso-width-alt:1440;width:34pt'>
 <col width=111 style='mso-width-source:userset;mso-width-alt:3552;width:83pt'>
 <col width=86 style='mso-width-source:userset;mso-width-alt:2752;width:65pt'>
 <col width=123 style='mso-width-source:userset;mso-width-alt:3936;width:92pt'>
 <col width=77 style='mso-width-source:userset;mso-width-alt:2464;width:58pt'>
 <col width=58 style='mso-width-source:userset;mso-width-alt:1856;width:44pt'>
 <col width=39 style='mso-width-source:userset;mso-width-alt:1248;width:29pt'>
 <col width=48 style='mso-width-source:userset;mso-width-alt:1536;width:36pt'>
 <col width=83 style='mso-width-source:userset;mso-width-alt:2656;width:62pt'>
 <col width=82 style='mso-width-source:userset;mso-width-alt:2624;width:62pt'>
 <col width=67 style='mso-width-source:userset;mso-width-alt:2144;width:50pt'>
 <col width=125 style='mso-width-source:userset;mso-width-alt:4000;width:94pt'>
 <col width=171 style='mso-width-source:userset;mso-width-alt:5472;width:128pt'>
 <tr height=59 style='mso-height-source:userset;height:44.25pt'>
  <td colspan=16 height=59 width=1273 style='height:44.25pt;width:956pt'
  align=left valign=top><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
   coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
   filled="f" stroked="f">
   <v:stroke joinstyle="miter"/>
   <v:formulas>
    <v:f eqn="if lineDrawn pixelLineWidth 0"/>
    <v:f eqn="sum @0 1 0"/>
    <v:f eqn="sum 0 0 @1"/>
    <v:f eqn="prod @2 1 2"/>
    <v:f eqn="prod @3 21600 pixelWidth"/>
    <v:f eqn="prod @3 21600 pixelHeight"/>
    <v:f eqn="sum @0 0 1"/>
    <v:f eqn="prod @6 1 2"/>
    <v:f eqn="prod @7 21600 pixelWidth"/>
    <v:f eqn="sum @8 21600 0"/>
    <v:f eqn="prod @7 21600 pixelHeight"/>
    <v:f eqn="sum @10 21600 0"/>
   </v:formulas>
   <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
   <o:lock v:ext="edit" aspectratio="t"/>
  </v:shapetype><v:shape id="_x0000_s1026" type="#_x0000_t75" style='position:absolute;
   margin-left:180pt;margin-top:9.75pt;width:33pt;height:27.75pt;z-index:1'>
   <v:imagedata src="<%=basePath %>parts/images/logo.jpg" o:title="logo"/>
   <x:ClientData ObjectType="Pict">
    <x:CF>Bitmap</x:CF>
   </x:ClientData>
  </v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout;
  position:absolute;z-index:1;margin-left:240px;margin-top:13px;width:44px;
  height:37px'><img width=44 height=37 src="<%=basePath %>parts/images/logo.jpg" v:shapes="_x0000_s1026"></span><![endif]><span
  style='mso-ignore:vglayout2'>
  <table cellpadding=0 cellspacing=0>
   <tr>
    <td colspan=16 height=59 class=xl33 width=1273 style='height:44.25pt;width:956pt'>好运来彩色印刷供应商信息列表</td>
   </tr>
  </table>
  </span></td>
  <td width=171 style='width:128pt'></td>
 </tr>
 <tr class=xl25 height=19 style='height:14.25pt'>
  <td height=19 class=xl26 style='height:14.25pt'>序号</td>
  <td class=xl27>供应商名称</td>
  <td class=xl28>供应商地址</td>
  <td class=xl28>供应类型</td>
  <td class=xl28>评级</td>
  <td class=xl28>税号</td>
  <td class=xl28>开户行</td>
  <td class=xl28>银行账号</td>
  <td class=xl28>银行户名</td>
  <td class=xl28>联系人</td>
  <td class=xl28>性别</td>
  <td class=xl28>职务</td>
  <td class=xl28>电话</td>
  <td class=xl28>手机</td>
  <td class=xl28>传真</td>
  <td class=xl28>邮箱</td>
  <td class=xl29>备注信息</td>
 </tr>
 <c:forEach items="${listinfo}" varStatus="status" var="rows">
 <tr height=19 style='height:14.25pt'>
  <td height=19 class=xl30 style='height:14.25pt'>${status.index+1}</td>
  <td class=xl31>${rows.suppliername}</td>
  <td class=xl31>${rows.address}</td>
  <td class=xl31>${rows.supplyflag}</td>
  <td class=xl31>${rows.grade}</td>
  <td class=xl31>${rows.dutyNumber}</td>
  <td class=xl31>${rows.bank}</td>
  <td class=xl31>${rows.banknumber}</td>
  <td class=xl31>${rows.bankname}</td>
  <td class=xl32>${rows.linkman}</td>
  <td class=xl32>${rows.sex}</td>
  <td class=xl31>${rows.duty}</td>
  <td class=xl31>${rows.telnumber}</td>
  <td class=xl31>${rows.phone}</td>
  <td class=xl31>${rows.faxnumber}</td>
  <td class=xl31>${rows.email}</td>
  <td class=xl31>${rows.remark}</td>
 </tr>
 </c:forEach>
	<c:if test="${empty listinfo}">
		<tr>
			<td colspan="17" align="center">暂时没有您可以浏览的数据</td>
		</tr>
	</c:if>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=31 style='width:23pt'></td>
  <td width=116 style='width:87pt'></td>
  <td width=114 style='width:86pt'></td>
  <td width=68 style='width:51pt'></td>
  <td width=45 style='width:34pt'></td>
  <td width=111 style='width:83pt'></td>
  <td width=86 style='width:65pt'></td>
  <td width=123 style='width:92pt'></td>
  <td width=77 style='width:58pt'></td>
  <td width=58 style='width:44pt'></td>
  <td width=39 style='width:29pt'></td>
  <td width=48 style='width:36pt'></td>
  <td width=83 style='width:62pt'></td>
  <td width=82 style='width:62pt'></td>
  <td width=67 style='width:50pt'></td>
  <td width=125 style='width:94pt'></td>
  <td width=171 style='width:128pt'></td>
 </tr>
 <![endif]>
</table>

</body>
</html>